USE [MyCarat]
GO
/****** Object:  StoredProcedure [dbo].[sp_RemovePic]    Script Date: 05/30/2012 18:11:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
if exists(select * from sysobjects where id=object_id('sp_RemovePic') )
        drop proc sp_RemovePic
GO
create proc [dbo].[sp_RemovePic]
  @id varchar(35)

  as
   begin tran
  delete from pics
   where ID=@id
    
    
   commit tran  